﻿CREATE TABLE [dbo].[Mobile_CheckRecentTransaction] (
    [ID]              UNIQUEIDENTIFIER NOT NULL,
    [Name]            NVARCHAR (50)    NULL,
    [Phone]           NVARCHAR (20)    NULL,
    [Email]           NVARCHAR (50)    NULL,
    [LocationKeyword] NVARCHAR (200)   NULL,
    [PropertyType]    NVARCHAR (10)    NULL,
    [SubmissionType]  NCHAR (10)       NULL,
    [CreatedDate]     DATETIME         CONSTRAINT [DF_Mobile_CheckRecentTransaction_CreatedDate] DEFAULT (getdate()) NULL,
    [isDelete]        SMALLINT         CONSTRAINT [DF_Mobile_CheckRecentTransaction_isDelete] DEFAULT ((0)) NULL,
    [UpdateDate]      DATETIME         NULL,
    CONSTRAINT [PK_Mobile_CheckRecentTransaction] PRIMARY KEY CLUSTERED ([ID] ASC)
);

